home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / t / rpl000017.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  583 b   |  22 lines  |  [TEXT/ttxt]
  1. connect (master,localhost,root,,test,0,mysql-master.sock);
  2. connect (slave,localhost,root,,test,0,mysql-slave.sock);
  3. connection master;
  4. reset master;
  5. grant file on *.* to replicate@localhost identified by 'aaaaaaaaaaaaaaab';
  6. grant file on *.* to replicate@127.0.0.1 identified by 'aaaaaaaaaaaaaaab';
  7. connection slave;
  8. slave start;
  9. connection master;
  10. drop table if exists t1;
  11. create table t1(n int);
  12. insert into t1 values(24);
  13. save_master_pos;
  14. connection slave;
  15. sync_with_master;
  16. select * from t1;
  17. connection master;
  18. drop table t1;
  19. save_master_pos;
  20. connection slave;
  21. sync_with_master;
  22.